<!DOCTYPE html>
<html lang="en-us">
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    
<meta charset="UTF-8">
<title>Functions and Operators | Elasticsearch Guide [7.7] | Elastic</title>
<link rel="home" href="index.html" title="Elasticsearch Guide [7.7]">
<link rel="up" href="xpack-sql.html" title="SQL access">
<link rel="prev" href="sql-index-frozen.html" title="Frozen Indices">
<link rel="next" href="sql-operators.html" title="Comparison Operators">
<meta name="DC.type" content="Learn/Docs/Elasticsearch/Reference/7.7">
<meta name="DC.subject" content="Elasticsearch">
<meta name="DC.identifier" content="7.7">
<meta name="robots" content="noindex,nofollow">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <script src="https://cdn.optimizely.com/js/18132920325.js"></script>
    <link rel="apple-touch-icon" sizes="57x57" href="/apple-icon-57x57.png">
    <link rel="apple-touch-icon" sizes="60x60" href="/apple-icon-60x60.png">
    <link rel="apple-touch-icon" sizes="72x72" href="/apple-icon-72x72.png">
    <link rel="apple-touch-icon" sizes="76x76" href="/apple-icon-76x76.png">
    <link rel="apple-touch-icon" sizes="114x114" href="/apple-icon-114x114.png">
    <link rel="apple-touch-icon" sizes="120x120" href="/apple-icon-120x120.png">
    <link rel="apple-touch-icon" sizes="144x144" href="/apple-icon-144x144.png">
    <link rel="apple-touch-icon" sizes="152x152" href="/apple-icon-152x152.png">
    <link rel="apple-touch-icon" sizes="180x180" href="/apple-icon-180x180.png">
    <link rel="icon" type="image/png" href="/favicon-32x32.png" sizes="32x32">
    <link rel="icon" type="image/png" href="/android-chrome-192x192.png" sizes="192x192">
    <link rel="icon" type="image/png" href="/favicon-96x96.png" sizes="96x96">
    <link rel="icon" type="image/png" href="/favicon-16x16.png" sizes="16x16">
    <link rel="manifest" href="/manifest.json">
    <meta name="apple-mobile-web-app-title" content="Elastic">
    <meta name="application-name" content="Elastic">
    <meta name="msapplication-TileColor" content="#ffffff">
    <meta name="msapplication-TileImage" content="/mstile-144x144.png">
    <meta name="theme-color" content="#ffffff">
    <meta name="naver-site-verification" content="936882c1853b701b3cef3721758d80535413dbfd">
    <meta name="yandex-verification" content="d8a47e95d0972434">
    <meta name="localized" content="true">
    <meta name="st:robots" content="follow,index">
    <meta property="og:image" content="https://www.elastic.co/static/images/elastic-logo-200.png">
    <link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
    <link rel="icon" href="/favicon.ico" type="image/x-icon">
    <link rel="apple-touch-icon-precomposed" sizes="64x64" href="/favicon_64x64_16bit.png">
    <link rel="apple-touch-icon-precomposed" sizes="32x32" href="/favicon_32x32.png">
    <link rel="apple-touch-icon-precomposed" sizes="16x16" href="/favicon_16x16.png">
    <!-- Give IE8 a fighting chance -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
    <link rel="stylesheet" type="text/css" href="/guide/static/styles.css">
  </head>

  <!--© 2015-2021 Elasticsearch B.V. Copying, publishing and/or distributing without written permission is strictly prohibited.-->

  <body>
    <!-- Google Tag Manager -->
    <script>dataLayer = [];</script><noscript><iframe src="//www.googletagmanager.com/ns.html?id=GTM-58RLH5" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
    <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= '//www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-58RLH5');</script>
    <!-- End Google Tag Manager -->

    <!-- Global site tag (gtag.js) - Google Analytics -->
    <script async src="https://www.googletagmanager.com/gtag/js?id=UA-12395217-16"></script>
    <script>
      window.dataLayer = window.dataLayer || [];
      function gtag(){dataLayer.push(arguments);}
      gtag('js', new Date());
      gtag('config', 'UA-12395217-16');
    </script>

    <!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->
    <script type="text/javascript">
      (function(){var g=function(e,h,f,g){
      this.get=function(a){for(var a=a+"=",c=document.cookie.split(";"),b=0,e=c.length;b<e;b++){for(var d=c[b];" "==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};
      this.set=function(a,c){var b="",b=new Date;b.setTime(b.getTime()+6048E5);b="; expires="+b.toGMTString();document.cookie=a+"="+c+b+"; path=/; "};
      this.check=function(){var a=this.get(f);if(a)a=a.split(":");else if(100!=e)"v"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(":"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case "v":return!1;case "r":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(":")),!c}return!0};
      this.go=function(){if(this.check()){var a=document.createElement("script");a.type="text/javascript";a.src=g;document.body&&document.body.appendChild(a)}};
      this.start=function(){var a=this;window.addEventListener?window.addEventListener("load",function(){a.go()},!1):window.attachEvent&&window.attachEvent("onload",function(){a.go()})}};
      try{(new g(100,"r","QSI_S_ZN_emkP0oSe9Qrn7kF","https://znemkp0ose9qrn7kf-elastic.siteintercept.qualtrics.com/WRSiteInterceptEngine/?Q_ZID=ZN_emkP0oSe9Qrn7kF")).start()}catch(i){}})();
    </script><div id="ZN_emkP0oSe9Qrn7kF"><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>
    <!--END WEBSITE FEEDBACK SNIPPET-->

    <div id="elastic-nav" style="display:none;"></div>
    <script src="https://www.elastic.co/elastic-nav.js"></script>

    <!-- Subnav -->
    <div>
      <div>
        <div class="tertiary-nav d-none d-md-block">
          <div class="container">
            <div class="p-t-b-15 d-flex justify-content-between nav-container">
              <div class="breadcrum-wrapper"><span><a href="/guide/" style="font-size: 14px; font-weight: 600; color: #000;">Docs</a></span></div>
            </div>
          </div>
        </div>
      </div>
    </div>

    <div class="main-container">
      <section id="content">
        <div class="content-wrapper">

          <section id="guide" lang="en">
            <div class="container">
              <div class="row">
                <div class="col-xs-12 col-sm-8 col-md-8 guide-section">
                  <!-- start body -->
                  <div class="page_header">
<strong>IMPORTANT</strong>: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
<a href="../current/index.html">current release documentation</a>.
</div>
<div id="content">
<div class="breadcrumbs">
<span class="breadcrumb-link"><a href="index.html">Elasticsearch Guide [7.7]</a></span>
»
<span class="breadcrumb-link"><a href="xpack-sql.html">SQL access</a></span>
»
<span class="breadcrumb-node">Functions and Operators</span>
</div>
<div class="navheader">
<span class="prev">
<a href="sql-index-frozen.html">« Frozen Indices</a>
</span>
<span class="next">
<a href="sql-operators.html">Comparison Operators »</a>
</span>
</div>
<div class="chapter xpack">
<div class="titlepage"><div><div>
<h2 class="title">
<a id="sql-functions"></a>Functions and Operators<a class="edit_me edit_me_private" rel="nofollow" title="Editing on GitHub is available to Elastic" href="https://github.com/elastic/elasticsearch/edit/7.7/docs/reference/sql/functions/index.asciidoc">edit</a><a class="xpack_tag" href="/subscriptions"></a>
</h2>
</div></div></div>
<p>Elasticsearch SQL provides a comprehensive set of built-in operators and functions:</p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<p><a class="xref" href="sql-operators.html" title="Comparison Operators">Operators</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-operators.html#sql-operators-equality" title="Equality (=)"><code class="literal">Equality (=)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators.html#sql-operators-null-safe-equality" title="Null safe Equality (&lt;=&gt;)"><code class="literal">Null safe Equality (&lt;=&gt;)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators.html#sql-operators-inequality" title="Inequality (&lt;&gt; or !=)"><code class="literal">Inequality (&lt;&gt; or !=)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators.html#sql-operators-comparison" title="Comparison (&lt;, &lt;=, &gt;, &gt;=)"><code class="literal">Comparison (&lt;, &lt;=, &gt;, &gt;=)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators.html#sql-operators-between" title="BETWEEN"><code class="literal">BETWEEN</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators.html#sql-operators-is-null" title="IS NULL/IS NOT NULL"><code class="literal">IS NULL/IS NOT NULL</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators.html#sql-operators-in" title="IN (&lt;value1&gt;, &lt;value2&gt;, ...)"><code class="literal">IN (&lt;value1&gt;, &lt;value2&gt;, ...)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-logical.html#sql-operators-and" title="AND"><code class="literal">AND</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-logical.html#sql-operators-or" title="OR"><code class="literal">OR</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-logical.html#sql-operators-not" title="NOT"><code class="literal">NOT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-math.html#sql-operators-plus" title="Add (+)"><code class="literal">Add (+)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-math.html#sql-operators-subtract" title="Subtract (infix -)"><code class="literal">Subtract (infix -)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-math.html#sql-operators-negate" title="Negate (unary -)"><code class="literal">Negate (unary -)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-math.html#sql-operators-multiply" title="Multiply (*)"><code class="literal">Multiply (*)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-math.html#sql-operators-divide" title="Divide (/)"><code class="literal">Divide (/)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-math.html#sql-operators-remainder" title="Modulo or Remainder(%)"><code class="literal">Modulo or Remainder(%)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-operators-cast.html#sql-operators-cast-cast" title="Cast (::)"><code class="literal">Cast (::)</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-like-rlike-operators.html" title="LIKE and RLIKE Operators">LIKE and RLIKE Operators</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-like-rlike-operators.html#sql-like-operator" title="LIKE"><code class="literal">LIKE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-like-rlike-operators.html#sql-rlike-operator" title="RLIKE"><code class="literal">RLIKE</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-aggs.html" title="Aggregate Functions">Aggregate Functions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-avg" title="AVG"><code class="literal">AVG</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-count" title="COUNT"><code class="literal">COUNT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-count-all" title="COUNT(ALL)"><code class="literal">COUNT(ALL)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-count-distinct" title="COUNT(DISTINCT)"><code class="literal">COUNT(DISTINCT)</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-first" title="FIRST/FIRST_VALUE"><code class="literal">FIRST/FIRST_VALUE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-last" title="LAST/LAST_VALUE"><code class="literal">LAST/LAST_VALUE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-max" title="MAX"><code class="literal">MAX</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-min" title="MIN"><code class="literal">MIN</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-sum" title="SUM"><code class="literal">SUM</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-kurtosis" title="KURTOSIS"><code class="literal">KURTOSIS</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-mad" title="MAD"><code class="literal">MAD</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-percentile" title="PERCENTILE"><code class="literal">PERCENTILE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-percentile-rank" title="PERCENTILE_RANK"><code class="literal">PERCENTILE_RANK</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-skewness" title="SKEWNESS"><code class="literal">SKEWNESS</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-stddev-pop" title="STDDEV_POP"><code class="literal">STDDEV_POP</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-sum-squares" title="SUM_OF_SQUARES"><code class="literal">SUM_OF_SQUARES</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-aggs.html#sql-functions-aggs-var-pop" title="VAR_POP"><code class="literal">VAR_POP</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-grouping.html" title="Grouping Functions">Grouping Functions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-grouping.html#sql-functions-grouping-histogram" title="HISTOGRAM"><code class="literal">HISTOGRAM</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-interval" title="Intervals">Date-Time Operators</a>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-datetime.html#sql-functions-current-date" title="CURRENT_DATE/CURDATE">Date-Time Functions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-current-date" title="CURRENT_DATE/CURDATE"><code class="literal">CURRENT_DATE/CURDATE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-current-time" title="CURRENT_TIME/CURTIME"><code class="literal">CURRENT_TIME/CURTIME</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-current-timestamp" title="CURRENT_TIMESTAMP"><code class="literal">CURRENT_TIMESTAMP</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-add" title="DATE_ADD/DATEADD/TIMESTAMP_ADD/TIMESTAMPADD"><code class="literal">DATE_ADD/DATEADD/TIMESTAMP_ADD/TIMESTAMPADD</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-diff" title="DATE_DIFF/DATEDIFF/TIMESTAMP_DIFF/TIMESTAMPDIFF"><code class="literal">DATE_DIFF/DATEDIFF/TIMESTAMP_DIFF/TIMESTAMPDIFF</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-part" title="DATE_PART/DATEPART"><code class="literal">DATE_PART/DATEPART</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-trunc" title="DATE_TRUNC/DATETRUNC"><code class="literal">DATE_TRUNC/DATETRUNC</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-day" title="DAY_OF_MONTH/DOM/DAY"><code class="literal">DAY_OF_MONTH/DOM/DAY</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-dow" title="DAY_OF_WEEK/DAYOFWEEK/DOW"><code class="literal">DAY_OF_WEEK/DAYOFWEEK/DOW</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-doy" title="DAY_OF_YEAR/DOY"><code class="literal">DAY_OF_YEAR/DOY</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-dayname" title="DAY_NAME/DAYNAME"><code class="literal">DAY_NAME/DAYNAME</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-hour" title="HOUR_OF_DAY/HOUR"><code class="literal">HOUR_OF_DAY/HOUR</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-isodow" title="ISO_DAY_OF_WEEK/ISODAYOFWEEK/ISODOW/IDOW"><code class="literal">ISO_DAY_OF_WEEK/ISODAYOFWEEK/ISODOW/IDOW</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-isoweek" title="ISO_WEEK_OF_YEAR/ISOWEEKOFYEAR/ISOWEEK/IWOY/IW"><code class="literal">ISO_WEEK_OF_YEAR/ISOWEEKOFYEAR/ISOWEEK/IWOY/IW</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-minuteofday" title="MINUTE_OF_DAY"><code class="literal">MINUTE_OF_DAY</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-minute" title="MINUTE_OF_HOUR/MINUTE"><code class="literal">MINUTE_OF_HOUR/MINUTE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-month" title="MONTH_OF_YEAR/MONTH"><code class="literal">MONTH_OF_YEAR/MONTH</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-monthname" title="MONTH_NAME/MONTHNAME"><code class="literal">MONTH_NAME/MONTHNAME</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-now" title="NOW"><code class="literal">NOW</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-second" title="SECOND_OF_MINUTE/SECOND"><code class="literal">SECOND_OF_MINUTE/SECOND</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-quarter" title="QUARTER"><code class="literal">QUARTER</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-today" title="TODAY"><code class="literal">TODAY</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-week" title="WEEK_OF_YEAR/WEEK"><code class="literal">WEEK_OF_YEAR/WEEK</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-year" title="YEAR"><code class="literal">YEAR</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-datetime.html#sql-functions-datetime-extract" title="EXTRACT"><code class="literal">EXTRACT</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-search.html" title="Full-Text Search Functions">Full-Text Search Functions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-search.html#sql-functions-search-match" title="MATCH"><code class="literal">MATCH</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-search.html#sql-functions-search-query" title="QUERY"><code class="literal">QUERY</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-search.html#sql-functions-search-score" title="SCORE"><code class="literal">SCORE</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-math.html" title="Mathematical Functions">Mathematical Functions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-abs" title="ABS"><code class="literal">ABS</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-cbrt" title="CBRT"><code class="literal">CBRT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-ceil" title="CEIL/CEILING"><code class="literal">CEIL/CEILING</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-e" title="E"><code class="literal">E</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-exp" title="EXP"><code class="literal">EXP</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-expm1" title="EXPM1"><code class="literal">EXPM1</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-floor" title="FLOOR"><code class="literal">FLOOR</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-log" title="LOG"><code class="literal">LOG</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-log10" title="LOG10"><code class="literal">LOG10</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-pi" title="PI"><code class="literal">PI</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-power" title="POWER"><code class="literal">POWER</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-random" title="RANDOM/RAND"><code class="literal">RANDOM/RAND</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-round" title="ROUND"><code class="literal">ROUND</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-sign" title="SIGN/SIGNUM"><code class="literal">SIGN/SIGNUM</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-sqrt" title="SQRT"><code class="literal">SQRT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-truncate" title="TRUNCATE/TRUNC"><code class="literal">TRUNCATE/TRUNC</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-acos" title="ACOS"><code class="literal">ACOS</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-asin" title="ASIN"><code class="literal">ASIN</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-atan" title="ATAN"><code class="literal">ATAN</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-atan2" title="ATAN2"><code class="literal">ATAN2</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-cos" title="COS"><code class="literal">COS</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-cosh" title="COSH"><code class="literal">COSH</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-cot" title="COT"><code class="literal">COT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-degrees" title="DEGREES"><code class="literal">DEGREES</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-radians" title="RADIANS"><code class="literal">RADIANS</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-sin" title="SIN"><code class="literal">SIN</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-sinh" title="SINH"><code class="literal">SINH</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-math.html#sql-functions-math-tan" title="TAN"><code class="literal">TAN</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-string.html" title="String Functions">String Functions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-ascii" title="ASCII"><code class="literal">ASCII</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-bit-length" title="BIT_LENGTH"><code class="literal">BIT_LENGTH</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-char" title="CHAR"><code class="literal">CHAR</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-char-length" title="CHAR_LENGTH"><code class="literal">CHAR_LENGTH</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-concat" title="CONCAT"><code class="literal">CONCAT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-insert" title="INSERT"><code class="literal">INSERT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-lcase" title="LCASE"><code class="literal">LCASE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-left" title="LEFT"><code class="literal">LEFT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-length" title="LENGTH"><code class="literal">LENGTH</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-locate" title="LOCATE"><code class="literal">LOCATE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-ltrim" title="LTRIM"><code class="literal">LTRIM</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-octet-length" title="OCTET_LENGTH"><code class="literal">OCTET_LENGTH</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-position" title="POSITION"><code class="literal">POSITION</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-repeat" title="REPEAT"><code class="literal">REPEAT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-replace" title="REPLACE"><code class="literal">REPLACE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-right" title="RIGHT"><code class="literal">RIGHT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-rtrim" title="RTRIM"><code class="literal">RTRIM</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-space" title="SPACE"><code class="literal">SPACE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-substring" title="SUBSTRING"><code class="literal">SUBSTRING</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-string.html#sql-functions-string-ucase" title="UCASE"><code class="literal">UCASE</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-type-conversion.html" title="Type Conversion Functions">Type Conversion Functions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-type-conversion.html#sql-functions-type-conversion-cast" title="CAST"><code class="literal">CAST</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-type-conversion.html#sql-functions-type-conversion-convert" title="CONVERT"><code class="literal">CONVERT</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-conditional.html" title="Conditional Functions And Expressions">Conditional Functions And Expressions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-conditional.html#sql-functions-conditional-case" title="CASE"><code class="literal">CASE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-conditional.html#sql-functions-conditional-coalesce" title="COALESCE"><code class="literal">COALESCE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-conditional.html#sql-functions-conditional-greatest" title="GREATEST"><code class="literal">GREATEST</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-conditional.html#sql-functions-conditional-ifnull" title="IFNULL"><code class="literal">IFNULL</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-conditional.html#sql-functions-conditional-iif" title="IIF"><code class="literal">IIF</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-conditional.html#sql-functions-conditional-isnull" title="ISNULL"><code class="literal">ISNULL</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-conditional.html#sql-functions-conditional-least" title="LEAST"><code class="literal">LEAST</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-conditional.html#sql-functions-conditional-nullif" title="NULLIF"><code class="literal">NULLIF</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-conditional.html#sql-functions-conditional-nvl" title="NVL"><code class="literal">NVL</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-geo.html" title="Geo Functions">Geo Functions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-geo.html#sql-functions-geo-st-as-wkt" title="ST_AsWKT"><code class="literal">ST_AsWKT</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-geo.html#sql-functions-geo-st-distance" title="ST_Distance"><code class="literal">ST_Distance</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-geo.html#sql-functions-geo-st-geometrytype" title="ST_GeometryType"><code class="literal">ST_GeometryType</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-geo.html#sql-functions-geo-st-wkt-to-sql" title="ST_WKTToSQL"><code class="literal">ST_WKTToSQL</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-geo.html#sql-functions-geo-st-x" title="ST_X"><code class="literal">ST_X</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-geo.html#sql-functions-geo-st-y" title="ST_Y"><code class="literal">ST_Y</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-geo.html#sql-functions-geo-st-z" title="ST_Z"><code class="literal">ST_Z</code></a>
</li>
</ul>
</div>
</li>
<li class="listitem">
<p><a class="xref" href="sql-functions-system.html" title="System Functions">System Functions</a></p>
<div class="ulist itemizedlist">
<ul class="itemizedlist">
<li class="listitem">
<a class="xref" href="sql-functions-system.html#sql-functions-system-database" title="DATABASE"><code class="literal">DATABASE</code></a>
</li>
<li class="listitem">
<a class="xref" href="sql-functions-system.html#sql-functions-system-user" title="USER"><code class="literal">USER</code></a>
</li>
</ul>
</div>
</li>
</ul>
</div>















</div>
<div class="navfooter">
<span class="prev">
<a href="sql-index-frozen.html">« Frozen Indices</a>
</span>
<span class="next">
<a href="sql-operators.html">Comparison Operators »</a>
</span>
</div>
</div>

                  <!-- end body -->
                </div>
                <div class="col-xs-12 col-sm-4 col-md-4" id="right_col">
                  <div id="rtpcontainer" style="display: block;">
                    <div class="mktg-promo">
                      <h3>Most Popular</h3>
                      <ul class="icons">
                        <li class="icon-elasticsearch-white"><a href="https://www.elastic.co/webinars/getting-started-elasticsearch?baymax=default&amp;elektra=docs&amp;storm=top-video">Get Started with Elasticsearch: Video</a></li>
                        <li class="icon-kibana-white"><a href="https://www.elastic.co/webinars/getting-started-kibana?baymax=default&amp;elektra=docs&amp;storm=top-video">Intro to Kibana: Video</a></li>
                        <li class="icon-logstash-white"><a href="https://www.elastic.co/webinars/introduction-elk-stack?baymax=default&amp;elektra=docs&amp;storm=top-video">ELK for Logs &amp; Metrics: Video</a></li>
                      </ul>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </section>

        </div>


<div id="elastic-footer"></div>
<script src="https://www.elastic.co/elastic-footer.js"></script>
<!-- Footer Section end-->

      </section>
    </div>

<script src="/guide/static/jquery.js"></script>
<script type="text/javascript" src="/guide/static/docs.js"></script>
<script type="text/javascript">
  window.initial_state = {}</script>
  </body>
</html>
